Model Table SLA ORDER

This model dimension represents the Service Level Agreements (SLA) Order data in form SLA Order and is based on the IFS Cloud dimension DIM_SLA Order. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Company CodeCompany Code
SLA OrderBuilt up as CODE + '- ' + DESCRIPTION
SLA Order CodeSLA Order Code
SLA Order Created ByUser ID of responsible for creating SLA Order
SLA Order Created DateCreated date of SLA Order
SLA Order DescSLA Order Description
SLA Order StatusSLA Order status Code
SLA Order Template IDSTemplate ID if SLA Order created from template

Hierarchies

Hierarchy Level
SLAOrderHy
Company Code
SLA Order

USED BY MODEL(S)

Model Name
Maintenance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
SLA ORDERDIM_SLA_ORDER_TMDIM_SLA_ORDER_BIDIM_SLA_ORDEROn Line